Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TaxRateRuleSequenceNumber (FK)(PK) | A squential number for theTaxRateRule, denoting the order of creation of the rules. | AI_TX_RT_RU | LineNumber | smallint | TaxRateRule(RU_TX_RT) |
TaxGroupRuleID (FK)(PK) | System assigned unique identifier for the TaxGroupRule. | ID_RU_TX_GRP | Identity | integer | TaxRateRule(RU_TX_RT) |
SessionID (FK)(PK) | A unique token ID for a Session instance. | ID_SSN | Identity | integer | Session(CO_SSN) |
TaxOnSalesTotalAmount | The total monetary amount of tax collected by SESSION. | CP_TX_CLT_TOT | Money | decimal(16,5) | |
TaxableSalesTotalAmount | The total monetary amount of taxable sales by SESSION.. | CP_SLS_TX_TOT | Money | decimal(16,5) | |
TaxExemptSalesTotalAmount | The total monetary amount of taxable sales by SESSION. | CP_SLS_TX_EXM_TOT | Money | decimal(16,5) | |
TaxExemptSalesCount | The total number of tax exempt transactions by SESSION | QU_TRN_TX_EXM | QuantityTransactionCount | decimal(7,0) | |